package utils.db.api;

import java.util.List;

import pojo.Device;

public interface IDeviceFetcher {

	public Device getDevice(Integer id);

	public List<Device> getDevices();

	public List<Device> getDevicesByIdServiceman(int id);
	
	public List<Device> getDeviceByIdClient(int id);
	
	public List<Device> getDeviceByState(String state);

	 String GET_DEVICE_BY_ID = "SELECT * from devices where id = ?";
	 String GET_ALL_DEVICES = "SELECT * from devices";
	 String GET_DEVICES_BY_ID_SERVICEMAN = "select * from devices where serviceman_id=?";
	 String GET_DEVICES_BY_ID_CLIENT = "select * from devices where client_id=?";
	 String GET_DEVICE_BY_STATE = "select * from devices where state = ?";
}
